The Standing Order data file from your bank must be in the format described below for iMIS to successfully import the file and to match the payment details to the correct Standing Order commitments. Contact your bank to obtain the Standing Order data file. They should be able to provide you with the software necessary to electronically download the file in the following format.
Note: Header and footer rows in the file are ignored during processing.
Barclays Standard Format Layout 1, 106 character data record
|
Field Number |
Field Size |
Character Position |
Description |
|
1. |
6 |
1-6 |
Sort Code of your account-holding branch. |
|
2. |
8 |
7-14 |
Account Number to which the payment has been applied. |
|
3. |
1 |
15 |
Account type. Note: Must be 0 for the iMIS import. |
|
4. |
2 |
16-17 |
Transaction code for the entry type. Note: Must be 99 for the iMIS import. |
|
5. |
6 |
18-23 |
Sort Code of the bank from which the payment originated. |
|
6. |
8 |
24-31 |
Account Number of the originating contact. |
|
7. |
4 |
32-35 |
The mandate identifier assigned by the originating bank. If none, this field is zero-filled. |
|
8. |
11 |
36-46 |
The amount of the entry in pence, unsigned, right-justified and left zero-filled. |
|
9. |
18 |
47-64 |
The originating customer name. |
|
10. |
18 |
65-82 |
The reference number quoted by, or on behalf of, the originating customer. In iMIS, this corresponds to the Match Reference Number. If entered, normally the field is left-justified and space-filled for unused characters. |
|
11. |
18 |
83-100 |
Space-filled field. |
|
12. |
6 |
101-106 |
The date the entry was applied to the bank account, in bYYDDD format (b = blank, DDD = Julian date). |
Sample Standing Order payment file